
/******************article_category*******************/
delete [tbl_article_category_item];
go
delete [tbl_article_category];
go
declare @cidp int, @cidc int, @cidcc int;
INSERT INTO [dbo].[tbl_article_category]
           ([images] ,[category_status] ,[category_sort] ,[category_param] ,[category_parent])
     VALUES ('anh.jpg',1 ,10 ,null ,null)
set @cidp = @@IDENTITY--(select top 1 category_id from [tbl_article_category] order by category_id desc)
INSERT INTO [dbo].[tbl_article_category_item]
([category_name],[category_alias],[category_item_enable],[language_id],[category_id])
VALUES
('danh muc 1','dm1',1,1,@cidp)
-- child
	INSERT INTO [dbo].[tbl_article_category]
           ([images] ,[category_status] ,[category_sort] ,[category_param] ,[category_parent])
     VALUES ('anh.jpg',1 ,10 ,null ,@cidp)
     set @cidc = @@IDENTITY
     INSERT INTO [dbo].[tbl_article_category_item]
	([category_name],[category_alias],[category_item_enable],[language_id],[category_id])
	VALUES
	('danh muc con 1','dmc1',1,1,@cidc)
	
		-- child level 3
		INSERT INTO [dbo].[tbl_article_category]
			   ([images] ,[category_status] ,[category_sort] ,[category_param] ,[category_parent])
		 VALUES ('anh.jpg',1 ,10 ,null ,@cidc)
		 set @cidcc = @@IDENTITY
		 INSERT INTO [dbo].[tbl_article_category_item]
		([category_name],[category_alias],[category_item_enable],[language_id],[category_id])
		VALUES
		('danh muc con 1.1.1','dmc111',1,1,@cidcc)
		INSERT INTO [dbo].[tbl_article_category]
			   ([images] ,[category_status] ,[category_sort] ,[category_param] ,[category_parent])
		 VALUES ('anh.jpg',1 ,10 ,null ,@cidc)
		 set @cidcc = @@IDENTITY
		 INSERT INTO [dbo].[tbl_article_category_item]
		([category_name],[category_alias],[category_item_enable],[language_id],[category_id])
		VALUES
		('danh muc con 1.1.2','dmc112',1,1,@cidcc)
		
     INSERT INTO [dbo].[tbl_article_category]
           ([images] ,[category_status] ,[category_sort] ,[category_param] ,[category_parent])
     VALUES ('anh.jpg',1 ,10 ,null ,@cidp)
     set @cidc = @@IDENTITY
     INSERT INTO [dbo].[tbl_article_category_item]
	([category_name],[category_alias],[category_item_enable],[language_id],[category_id])
	VALUES
	('danh muc con 2','dmc2',1,1,@cidc)
     INSERT INTO [dbo].[tbl_article_category]
           ([images] ,[category_status] ,[category_sort] ,[category_param] ,[category_parent])
     VALUES ('anh.jpg',1 ,10 ,null ,@cidp)
     set @cidc = @@IDENTITY
     INSERT INTO [dbo].[tbl_article_category_item]
	([category_name],[category_alias],[category_item_enable],[language_id],[category_id])
	VALUES
	('danh muc con 3','dmc3',1,1,@cidc)


INSERT INTO [dbo].[tbl_article_category]
           ([images] ,[category_status] ,[category_sort] ,[category_param] ,[category_parent])
     VALUES ('anh.jpg',1 ,10 ,null ,null)
set @cidp = @@IDENTITY--(select top 1 category_id from [tbl_article_category] order by category_id desc)
INSERT INTO [dbo].[tbl_article_category_item]
([category_name],[category_alias],[category_item_enable],[language_id],[category_id])
VALUES
('danh muc 2','dm2',1,1,@cidp)
-- child
	INSERT INTO [dbo].[tbl_article_category]
           ([images] ,[category_status] ,[category_sort] ,[category_param] ,[category_parent])
     VALUES ('anh.jpg',1 ,10 ,null ,@cidp)
     set @cidc = @@IDENTITY
     INSERT INTO [dbo].[tbl_article_category_item]
	([category_name],[category_alias],[category_item_enable],[language_id],[category_id])
	VALUES
	('danh muc con 2.1','dmc21',1,1,@cidc)
     INSERT INTO [dbo].[tbl_article_category]
           ([images] ,[category_status] ,[category_sort] ,[category_param] ,[category_parent])
     VALUES ('anh.jpg',1 ,10 ,null ,@cidp)
     set @cidc = @@IDENTITY
     INSERT INTO [dbo].[tbl_article_category_item]
	([category_name],[category_alias],[category_item_enable],[language_id],[category_id])
	VALUES
	('danh muc con 2.2','dmc22',1,1,@cidc)
     INSERT INTO [dbo].[tbl_article_category]
           ([images] ,[category_status] ,[category_sort] ,[category_param] ,[category_parent])
     VALUES ('anh.jpg',1 ,10 ,null ,@cidp)
     set @cidc = @@IDENTITY
     INSERT INTO [dbo].[tbl_article_category_item]
	([category_name],[category_alias],[category_item_enable],[language_id],[category_id])
	VALUES
	('danh muc con 2.3','dmc23',1,1,@cidc)



INSERT INTO [dbo].[tbl_article_category]
           ([images] ,[category_status] ,[category_sort] ,[category_param] ,[category_parent])
     VALUES ('anh.jpg',1 ,10 ,null ,null)
set @cidp = @@IDENTITY--(select top 1 category_id from [tbl_article_category] order by category_id desc)
INSERT INTO [dbo].[tbl_article_category_item]
([category_name],[category_alias],[category_item_enable],[language_id],[category_id])
VALUES
('danh muc 3','dm3',1,1,@cidp)
-- child
	INSERT INTO [dbo].[tbl_article_category]
           ([images] ,[category_status] ,[category_sort] ,[category_param] ,[category_parent])
     VALUES ('anh.jpg',1 ,10 ,null ,@cidp)
     set @cidc = @@IDENTITY
     INSERT INTO [dbo].[tbl_article_category_item]
	([category_name],[category_alias],[category_item_enable],[language_id],[category_id])
	VALUES
	('danh muc con 3.1','dmc31',1,1,@cidc)
     INSERT INTO [dbo].[tbl_article_category]
           ([images] ,[category_status] ,[category_sort] ,[category_param] ,[category_parent])
     VALUES ('anh.jpg',1 ,10 ,null ,@cidp)
     set @cidc = @@IDENTITY
     INSERT INTO [dbo].[tbl_article_category_item]
	([category_name],[category_alias],[category_item_enable],[language_id],[category_id])
	VALUES
	('danh muc con 3.2','dmc32',1,1,@cidc) 